CREATE VIEW [dbo].[vSoaGroupClassSummary] AS
SELECT CAST('DUES' AS VARCHAR(20)) AS GroupClassId, 'Dues' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('SUB' AS VARCHAR(20)) AS GroupClassId, 'Subscription' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('SEC' AS VARCHAR(20)) AS GroupClassId, 'Section' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('CHAPT' AS VARCHAR(20)) AS GroupClassId, 'Chapter' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('VOL' AS VARCHAR(20)) AS GroupClassId, 'Voluntary Contribution' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('MISC' AS VARCHAR(20)) AS GroupClassId, 'Miscellaneous' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('COMMITTEE' AS VARCHAR(20)) AS GroupClassId, 'Committee' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('MT' AS VARCHAR(20)) AS GroupClassId, 'Member Type' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(1 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('EVENT' AS VARCHAR(20)) AS GroupClassId, 'Event' AS Name, '' AS Description,
    CAST(1 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(1 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('RELATIONSHIP' AS VARCHAR(20)) AS GroupClassId, 'Relationship' AS Name, '' AS Description,
    CAST(0 AS BIT) AS [IsReadOnly], CAST(1 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]
UNION
SELECT CAST('ORGRELATIONSHIP' AS VARCHAR(20)) AS GroupClassId, 'Organization' AS Name, '' AS Description,
    CAST(0 AS BIT) AS [IsReadOnly], CAST(0 AS BIT) AS [IsRelationshipGroup], CAST(0 AS BIT) AS [IsSimpleGroup]






GO